package com.chixing.mapper;

import com.chixing.entity.Department;
import com.chixing.entity.Employee;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface EmployeeMapper extends BaseMapper<Employee>{
    public int delete(int Empno);
    public Employee selectById(int Empno);
    // 多条件查询员工： 员工编号，姓名，职位，部门，薪资范围
    public List<Employee> selectByMoreConditions(@Param("empno") Integer empno,
                                                 @Param("empname") String empname,
                                                 @Param("empJob") String empJob,
                                                 @Param("deptNo") Integer deptNo,
                                                 @Param("minSalary") Float minSalary,
                                                 @Param("maxSalary") Float maxSalary);
    public List<Employee> selectByDeptNo(Integer[] deptNos);
    //模糊查询的方法
    public List<Employee> selectByLikeName(String empname);
    //分页查询员工信息（薪资降序，每页显示3条记录）
    public List<Employee> selectByPage(int startPosition);

}
